home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Aminet 24
/
Aminet 24 (1998)(GTI - Schatztruhe)[!][Apr 1998].iso
/
Aminet
/
biz
/
dbase
/
Aminet2DB.lha
/
Aminet2CSV.rexx
next >
Wrap
OS/2 REXX Batch file
|
1998-01-28
|
1KB
|
38 lines
/*
* Aminet2CSV.rexx
* Converts Aminet RECENT file to comma-separated values.
* $VER: Aminet2CSV.rexx 1.0 (22.11.97)
* By Deok-Min Yun
* ProCalc had a problem with missing entries. Need to enter an empty space.
*/
OPTIONS RESULTS
PARSE ARG filename
IF OPEN('DataFile', filename, 'R') = 1 THEN DO
IF OPEN('SaveFile', filename||'.CSV', 'W') = 1 THEN DO
buffer = 'File,Dir,Size,Description'
CALL WRITELN('SaveFile', buffer)
DO FOREVER
temp = READLN('DataFile')
IF EOF('DataFile') THEN BREAK
e_name = STRIP(LEFT(temp, 18))
e_middle = SUBSTR(temp, 20, 15)
PARSE VAR e_middle e_dir e_size
e_size = STRIP(e_size)
e_comment = TRANSLATE(SUBSTR(temp, 36), "'", '"')
IF INDEX(e_name, ".") ~= 0 & INDEX(e_dir, "/") ~= 0 &,
(INDEX(e_size, "K") ~= 0 | INDEX(e_size, "M") ~= 0) THEN DO
IF INDEX(e_name, ",") ~= 0 THEN e_name = '"'e_name'"'
IF INDEX(e_comment, ",") ~= 0 THEN e_comment = '"'e_comment'"'
buffer = e_name','e_dir','e_size','e_comment
CALL WRITELN('SaveFile', buffer)
END
END
CALL CLOSE('SaveFile')
END
ELSE SAY "Couldn't create a new file."
CALL CLOSE('DataFile')
END
ELSE SAY "Couldn't open original file."